Table Declaration example

The Table Declarations are added to either the Control File or the Data Transformation script file. They specify the data type and format of the table to be loaded.

The following example displays the table declaration for the Person table. The declaration states that the file to be imported is a flat file, and therefore has no delimiters. The record length is 81 and the table type is refresh, so any existing data will be overwritten.

• Editing Scripts
  • Using The iLoader Editing Tools
  • Using the Table Declaration Wizard
  • Table Declaration File Structure
  • Table Declaration Example
  • Using the Table Definition Wizard
  • Table Definition File Structure
  • Table Definition Example
  • Indexing Fields
  • Creating Scripts Manually